home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 14 / Developer Source Volume 14 (I-MODE Publications, Inc.)(1999).iso / orinf / nov96 / lopaf102.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  23KB  |  305x413  |  4-bit (16 colors)
Labels: text | screenshot | font | number | document | parallel
OCR: Step Description ALTER TS1 BEGIN BACKUP This puts the tablespace into hot backup mode, so oll changes made to the segments in the tablespace ore recorded in the redo log files until the tablespace is taken out of hot backup mode. O/S backup of TS1 An operating system backup of the data files associated with the tablespace is performed. ALTER TS1 END BACKUP This returns the tablespace to normal mode, after which any changes that were made to the segments in the tablespace are now mode. Repeat for all tablespaces Repeat first three steps for all table spaces, including the system tablespace. Create backup control file Issue the command ALTER DATABASE BACKUP CONTROLFILE to create a backup copy of the control file. Then, copy the newly-generated file to the backup destinotion, Switch all log files Switch all log file groups to record any changes made during the hot backups. After the log files have been archived, copy them to the backup destination. Backup database scripts Copy the database scripts to the backup destination, Figure 2: Steps in a hot-full backup.